SELECT ORG_ROLE."NAME",ORG_ROLE.CODE FROM ORG_RELATIONSHIP 
LEFT JOIN ORG_ROLE ON ORG_ROLE."ID" = ORG_RELATIONSHIP.OBJECTIVE1_ID
LEFT JOIN ORG_MEMBER ON ORG_MEMBER."ID" = ORG_RELATIONSHIP.SOURCE_ID AND ORG_MEMBER.ORG_ACCOUNT_ID = ORG_RELATIONSHIP.OBJECTIVE0_ID
WHERE ORG_RELATIONSHIP."TYPE" = 'Member_Role' AND ORG_RELATIONSHIP.SOURCE_ID = '${memberId}' AND ORG_ROLE.CODE = 'BatchProcessing'